<?php
require_once '../registro_ds/conexao_ciec.php';
require_once '../registro_ds/funcoes.php';
$query = mysql_query("SELECT
idPasta,
idInstituicao,if(Situacao=1,'Ativa',if(Situacao=2,'Extinta',if(Situacao=3,'Suspensa',if(Situacao=4,'Indeferido','Descredenciada')))) as situacao
FROM redeparticular order by idPasta") or die("Erro ao listar registro de diretores - ".mysql_error());

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>.:Lista Escolas/Pastas:.</title>
<link rel="stylesheet" type="text/css" href="../css/public.css">
</head>

<body>
<table width="600" border="1" align="center">
  <tr>
    <td><div align="center"><strong>.:Rela&ccedil;&atilde;o de Pastas:.</strong></div></td>
  </tr>
</table>
<table width="600" border="1" align="center">
  <tr>
    <td width="63"><div align="center"><strong>Pasta</strong></div></td>
    <td width="290"><div align="center"><strong>Nome</strong></div></td>
    <td width="125"><div align="center"><strong>Situa&ccedil;&atilde;o</strong></div></td>
  </tr>
</table>
<?php
while($dados = mysql_fetch_array($query))
{
?>
<table width="600" border="0" align="center">
  <tr>
    <td><table width="600" border="1" align="center">
      <tr>
        <td width="63" bgcolor="#FFFFFF"><div align="center"><strong><?php echo $dados['idPasta'];;?></strong></div></td>
        <td width="290" bgcolor="#FFFFFF"><div align="center"><strong><?php echo $dados['idInstituicao'];?></strong></div></td>
        <td width="125" bgcolor="#FFFFFF"><div align="center"><strong><?php echo dataBR($dados['situacao']);?></strong></div></td>
      </tr>
    </table></td>
  </tr>
</table>
<?php
}
?>
<p>&nbsp;</p>
</body>
</html>
